Sales by Menu Item Report

The Sales by Menu Item command allows you to generate a report showing the number of menu items sold in a specified time period for functions associated with group bookings, by either POS type or time period (Note: Time Period may NOT match POS Type. Time Period is based on the actual date/time and POS Type is based on system date). The results shown may be filtered by several categories including Group Status, POS Type, Pick Category, Sales Manager, Catering Manager and Conference Services Manager to give you detailed information on which of your menu items were sold, the count of menu items sold and their associated price, allowing you to see exactly what has been sold and for how much, and to therefore make purchasing adjustments based on your supply and demand of menu items.

The Sales by Menu Item command can be found in the Reports section of the Sales and Catering Area of Skyware.

If your Property does not currently have our Sales and Catering Module and you are interested in adding it, please contact us at  Sales@SkywareSystems.com.

 

 

 

The Sales and Catering Menu may be reached either directly from the Quick Menu, or by using the Full Menu and selecting Sales and Catering => from the Other section.

1. Select Sales and Catering => from the Quick Menu (left side of screen).

Quick Menu with Sales and Catering command selected OR Section of Quick Menu with Sales and Catering command selected, NEW look for Skyware

OR

2. Select Sales and Catering => from the Other section of the Full Menu,

Click the icon on the left for the Full menu.

Full Menu Icon OR Full Menu option when viewed using the modern light look of Skyware

This will display the Full menu in a tabular form, with four sections, Registration, Status, Cashier and Other.

Full Menu Table OR Full Menu popup version seen in Modern Light look of Skyware

Select Sales and Catering => from the Other section.

Other Section of the Full Menu with Sales and Catering command selected OR Other section of the Full Menu with Sales and Catering => command selected, NEW look for Skyware

This will display the Sales and Catering menu in a tabular form, with four sections, Selling Tools, Groups, Sales Reports and Catering Reports.

Sales and Catering Menu screen OR Sales and Catering menu pop up shown in new Skyware look

The Sales by Menu Item command is in the Catering Reports section.

Catering Reports section of the Sales and catering Menu with Sales by Menu Item command selected, NEW look for Skyware

 

When selected the Sales by Menu Item screen will open.

Sales by Menu Item screen example

 

The Sales by Menu Item screen has several options for you to select from.

 

Report Date: Select the Date range that you wish to use for the report. By default the date selected for both start and end date is today's date, meaning the generated report will show one day, today's, information.

Start Date: Click within the field to open the calendar icon to select the date to begin the reporting. By default the date selected is today's date.

End Date: Click within the field to open the calendar icon to select the date to end the reporting. By default the date selected is today's date.

 

Report By: Use the radial buttons to select your desired options for the report. By default, POS Type and show Price are selected.

POS Type OR Time Period: As mentioned earlier, these options may NOT match. Time Period is based on the actual date/time and POS Type is based on system date. If POS Type is selected the report will show a break down of the menu items by POS Type (for example, Food, Beverage, Beer/Wine, Liquor or Other) which make up the Menu (such as Continental Breakfast, Deli Buffet) or item (such as cosmopolitan, heinekin bottle) description, whereas if Time period is selected, you will see only the menu or item description and its price/cost listed only.

Show Price OR Show Cost: Price is the amount that the menu item is sold for by you; cost is the amount that the menu item costs you.

 

Report Options: There are several options which may be selected from to filter the information shown on the report by - for example, the report can be filtered by various Manager categories, to allow you to show the Sales by Menu Item associated with a particular Manager only if wished. By default, ALL is selected. for each filtering option

Group Status: Use the drop down menu to select from All, Definite, Tentative or Prospect. By default, All is selected.

POS Type: This option allows you to filter the report by a particular POS Type if desired. Use the drop down menu to select ONE from your available POS Types (All, Food, Beverage, Beer/Wine, Liquor or Other). By default, All is selected.

Pick Category: This option allows you to filter the report by a particular Pick Category if desired. The drop down menu lists all Pick Categories entered into Skyware as available for selection. Use the drop down menu to select ONE from your Pick Categories. By default, All is selected.

Sales Manager: This option allows you to filter the report by a particular Sales Manager if desired. The drop down menu lists all Sales Managers available for selection. By default, All is selected. Select any ONE Sales Manager to show on the report if desired.

Catering Manager: This option allows you to filter the report by a particular Catering Manager if desired. The drop down menu lists all Catering Managers available for selection. By default, All is selected. Select any ONE Catering Manager to show on the report if desired.

Conference Services Manager: This option allows you to filter the report by a particular Conference Services Manager if desired. The drop down menu lists all Conference Services Managers available for selection. By default, All is selected. Select any ONE Conference Services Manager to show on the report if desired.

Note: Any Skyware User may be designated as a Sales Manager, Catering Manager or Conference Services Manager on the User profile screen.

Show Details: this check box may be checked or unchecked,. By default it is unchecked. If checked, the description will also contain the group name and confirmation code associated with the menu or item description.

 

When finished, click the button Show Report.

Sales by Item by POS Type report example:

Sales by Item by POS Type Report example

Sales by Item by POS Type report example when the "show details" checkbox has been selected :

Sales by Item by POS Type report example when the "show details" checkbox has been selected example

Sales by Item by Time Period report example:

Sales by Item by Time Period report example

 

By default, the report is generated in PDF form and opens in a separate browser window. From there you can select to save or print the report, among other options. You can, instead, check the Generate report to excel checkbox to generate the report in HTML for downloading to Excel instead of PDF. The information in this case will then be correct for importing into another document rather than immediate viewing. Or, check the Generate report to excel (data only) checkbox to export the information on the report as data only.

 

Date Updated August 21, 2025